Accounts Assistant Practical Training

The Accounts Assistant training program is designed to equip you with the skills that you need to secure a job as an Accounts Assistant. Upon completion, you will have a good understanding of the financial process from purchase and sales Ledger to extended trial balance including bank reconciliations and VAT. You will be using various accounting software during the training e.g. Sage 50, QuickBooks, Excel and Xero.

According to AAT Salary survey, the average salary of an Accounts Assistant is £30k with steady growth and openings in the year 2023. Course duration and price depends on the contents and number of software chosen by the candidate. At the end of the Accounts Assistant Training program, you will be provided with a guaranteed work placement.

We are official partners with Sage, QuickBooks and Xero and all our trainees get official Sage, QuickBooks and Xero certifications upon completion of Accounts Assistant training.

The Price Advertised is Per Software

1. Train now later options available (Applicable on the full program)
2. Flexible Payment Options Available (Applicable on the full program)

Discounted offer depends on course content, delivery method, and number of software covered

• Practical Accountancy Training - > download

We have carefully designed Accounts Assistant training program to cover all the the skills required by employers for Accounts Assistant positions. Accounts Assistant Training will be delivered on real company files by our qualified chartered accountants.

Bookkeeping, VAT & HMRC Reporting (Sage 50, QuickBooks and Xero)

• Setting up companies using various VAT schemes, i.e Standard VAT Scheme, Cash Accounting Scheme, Flat Rate Scheme, Marginal VAT Scheme
• Choosing the chart of accounts that suits the ?rm's needs and its customisation
• Understanding how double entry is applied in accounting software and how to customise the nominal ledger and nominal codes
• Setting up customers accounts and processing sales invoices
• Setting up suppliers accounts and processing purchase invoices
• Generating customer/supplier invoice reports
• Generating customer/supplier statements
• Generating aged debtors and aged creditors reports
• Understanding CIS deductions and processing invoice containing CIS element
• Understanding reverse charge and processing invoice containing reverse charge element
• Identifying errors and performing error corrections
• Allocating cash payments and receipts
• Allocating bank payments and receipts
• Performing bank reconciliation / petty cash reconciliation
• Calculating VAT for businesses with mixed zero-rated and standard-rated sales combining Sage and Excel
• Preparing the VAT return
• Reconciling the VAT return
• Submitting the VAT return to HMRC
• Dealing with HMRC queries
• VAT registration and deregistration process
• Rules regarding Cash VAT and Flat Rate VAT scheme
• Deeper understanding of Standard VAT Scheme, Cash Accounting Scheme, Flat Rate Scheme, Marginal VAT Scheme and VAT Retail Scheme
• VAT deadlines and penalties

Accounts Assistant Practical Training (Sage 50, QuickBooks and Xero)

• Treatment of opening balances
• Foreign currency invoices
• Treatment of different types of discounts on invoices
• Reconciliation of debtors and creditors control accounts
• Generating aged debtors and aged creditors reports for credit control purposes
• Reconciliation of VAT, PAYE and Wages control accounts
• Posting month end adjustments and journals
• Understanding accruals and processing the journal entry
• Understanding prepayments and processing the journal entry
• Maintaining fixed asset register of the organisation
• Writing off fixed assets
• Calculating depreciation using different methods
• Understanding gains and losses on disposals of assets
• Suspense account reconciliation
• Director’s loan account
• Loan amortisation account
• Treatment of dividends
• Preparing VAT using Standard VAT Scheme, Cash Accounting Scheme, Flat Rate Scheme, Marginal VAT Scheme
• Preparing closing entries
• Preparing the Final Trial Balance
• Monthly management accounts
• Running the year end procedures in Sage 50 Accounts to close the ?nancial year and start a new ?nancial year

Payroll Processing and HMRC Reporting (Sage Payroll)

• Understanding UK legislation relating to Payroll
• Registering as an employer
• Understanding Pay as you earn (PAYE) system
• NIC classes and rate
• Income tax bands and rates
• Adding employees into payroll software
• Creating pay elements
• Understanding year to date values
• Processing payments for employees
• Generating payslips
• Generating pre-update reports
• Departments and employee analysis
• Calculating and Processing statutory payments
• Calculating and paying statutory sick pay (SSP)
• Calculating and paying statutory maternity pay (SMP)
• Calculating and paying statutory paternity pay (SPP)
• Recording absences
• Updating the payroll records with leavers and joiners
• Payment by BACS
• Yearend procedures
• Printing and Issuing pay slips to employees
• Real time information (RTI) reports
• Full payment submission (FPS)
• Employer payment summary (EPS)
• Submitting PAYE to HMRC
• Issuing P45 to employees when they leave
• Issuing P60’s to employees at the end of each tax year

Advanced Excel Training

• Summing Techniques
• IF, Cell References, Formula Linking etc
• New Formulas of Excel 2007 Sumifs, Countifs, Iferror
• Database Formulas
• Subtotal (Formulae & Procedure)
• Tables
• Macros
• Look up References (Vlookup, Hlookup etc)
• Data Validation
• Conditional Formatting
• Date & Time Formulas
• Charts & Graphs
• Protection & Security
• Goal Seek
• Groupings
• Pivot Table
• Pivot Table Charts
• Hyperlinks
• Scenario
• H-Look ups
• V-Lookups
• Web workbooks

After completing Accounts Assistant Training We help all of our trainees in preparing professional CV and job interviews and we Guarantee Work Placement.

Accounts Assistant Training is ideal for

• Those who have no prior experience or qualification in accountancy
• Candidates currently studying ACCA, AAT, CIMA or other accountancy qualifications but have no practical accountancy and payroll experience
• Candidates with overseas accounting experience but not within the UK
• Candidates new to Computerised accounting
• Work Placement is Guaranteed only if you choose any of our structured program delivered in office.

Accounts Assistant training also covers all the areas of Bookkeeping, VAT and Payroll

Accounts Assistant Training has no requirements. In this training you start from the basic bookkeeping and then advance towards the higher concepts.

Our in-depth Accounts Assistant training is perfect fit for you to gain the skills set demanded by the employers.

After completing Accounts Assistant Training you can apply for jobs such as

Accounts Assistant.

Accounts Receivables / Payable

Credit Controller

Finance Assistant

Junior Accountant